Bank Loans Data Report

Dataset statistics

Number of variables	9
Number of observations	850
Missing cells	150
Missing cells (%)	2.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	59.9 KiB
Average record size in memory	72.2 B

Variable types

Numeric	7
Categorical	2

Alerts

`age` is highly overall correlated with `employ` and 2 other fields	High correlation
`employ` is highly overall correlated with `age` and 1 other fields	High correlation
`address` is highly overall correlated with `age`	High correlation
`income` is highly overall correlated with `age` and 3 other fields	High correlation
`debtinc` is highly overall correlated with `creddebt` and 1 other fields	High correlation
`creddebt` is highly overall correlated with `income` and 2 other fields	High correlation
`othdebt` is highly overall correlated with `income` and 2 other fields	High correlation
`default` has 150 (17.6%) missing values	Missing
`employ` has 72 (8.5%) zeros	Zeros
`address` has 60 (7.1%) zeros	Zeros

Reproduction

Analysis started	2024-01-11 16:34:55.917979
Analysis finished	2024-01-11 16:35:18.689064
Duration	22.77 seconds
Software version	pandas-profiling v3.6.6
Download configuration	config.json

age
Real number (ℝ)

Distinct	37
Distinct (%)	4.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	35.029412

Minimum	20
Maximum	56
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	6.8 KiB

Quantile statistics

Minimum	20
5-th percentile	23
Q1	29
median	34
Q3	41
95-th percentile	49
Maximum	56
Range	36
Interquartile range (IQR)	12

Descriptive statistics

Standard deviation	8.0414316
Coefficient of variation (CV)	0.22956228
Kurtosis	-0.65755007
Mean	35.029412
Median Absolute Deviation (MAD)	6
Skewness	0.3350366
Sum	29775
Variance	64.664623
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=37)

Value	Count	Frequency (%)
29	51	6.0%
31	42	4.9%
39	41	4.8%
35	40	4.7%
34	38	4.5%
28	38	4.5%
41	36	4.2%
36	33	3.9%
27	33	3.9%
40	32	3.8%
Other values (27)	466	54.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
20	2	0.2%
21	12	1.4%
22	14	1.6%
23	21	2.5%
24	30	3.5%
25	25	2.9%
26	30	3.5%
27	33	3.9%
28	38	4.5%
29	51	6.0%

Value	Count	Frequency (%)
56	2	0.2%
55	2	0.2%
54	4	0.5%
53	7	0.8%
52	9	1.1%
51	7	0.8%
50	11	1.3%
49	5	0.6%
48	19	2.2%
47	22	2.6%

ed
Categorical

Distinct	5
Distinct (%)	0.6%
Missing	0
Missing (%)	0.0%
Memory size	6.8 KiB

1	460
2	235
3	101
4	49
5	5

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	850
Distinct characters	5
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	3
2nd row	1
3rd row	1
4th row	1
5th row	2

Common Values

Value	Count	Frequency (%)
1	460	54.1%
2	235	27.6%
3	101	11.9%
4	49	5.8%
5	5	0.6%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1	460	54.1%
2	235	27.6%
3	101	11.9%
4	49	5.8%
5	5	0.6%

Most occurring characters

Value	Count	Frequency (%)
1	460	54.1%
2	235	27.6%
3	101	11.9%
4	49	5.8%
5	5	0.6%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	850	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	460	54.1%
2	235	27.6%
3	101	11.9%
4	49	5.8%
5	5	0.6%

Most occurring scripts

Value	Count	Frequency (%)
Common	850	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
1	460	54.1%
2	235	27.6%
3	101	11.9%
4	49	5.8%
5	5	0.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	850	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	460	54.1%
2	235	27.6%
3	101	11.9%
4	49	5.8%
5	5	0.6%

employ
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	33
Distinct (%)	3.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	8.5658824

Minimum	0
Maximum	33
Zeros	72
Zeros (%)	8.5%
Negative	0
Negative (%)	0.0%
Memory size	6.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	3
median	7
Q3	13
95-th percentile	21.55
Maximum	33
Range	33
Interquartile range (IQR)	10

Descriptive statistics

Standard deviation	6.7778836
Coefficient of variation (CV)	0.79126508
Kurtosis	0.37920084
Mean	8.5658824
Median Absolute Deviation (MAD)	5
Skewness	0.86266291
Sum	7281
Variance	45.939706
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=33)

Value	Count	Frequency (%)
0	72	8.5%
1	59	6.9%
4	57	6.7%
6	53	6.2%
9	52	6.1%
2	50	5.9%
3	50	5.9%
5	49	5.8%
7	45	5.3%
10	38	4.5%
Other values (23)	325	38.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	72	8.5%
1	59	6.9%
2	50	5.9%
3	50	5.9%
4	57	6.7%
5	49	5.8%
6	53	6.2%
7	45	5.3%
8	38	4.5%
9	52	6.1%

Value	Count	Frequency (%)
33	2	0.2%
31	3	0.4%
30	3	0.4%
29	2	0.2%
28	1	0.1%
27	3	0.4%
26	1	0.1%
25	4	0.5%
24	5	0.6%
23	6	0.7%

address
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	32
Distinct (%)	3.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	8.3717647

Minimum	0
Maximum	34
Zeros	60
Zeros (%)	7.1%
Negative	0
Negative (%)	0.0%
Memory size	6.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	3
median	7
Q3	12
95-th percentile	22.55
Maximum	34
Range	34
Interquartile range (IQR)	9

Descriptive statistics

Standard deviation	6.8950164
Coefficient of variation (CV)	0.8236037
Kurtosis	0.25679934
Mean	8.3717647
Median Absolute Deviation (MAD)	5
Skewness	0.92379061
Sum	7116
Variance	47.541251
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=32)

Value	Count	Frequency (%)
1	71	8.4%
2	71	8.4%
0	60	7.1%
4	58	6.8%
3	55	6.5%
6	50	5.9%
8	49	5.8%
9	45	5.3%
5	43	5.1%
7	41	4.8%
Other values (22)	307	36.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	60	7.1%
1	71	8.4%
2	71	8.4%
3	55	6.5%
4	58	6.8%
5	43	5.1%
6	50	5.9%
7	41	4.8%
8	49	5.8%
9	45	5.3%

Value	Count	Frequency (%)
34	1	0.1%
31	2	0.2%
30	1	0.1%
29	1	0.1%
27	4	0.5%
26	10	1.2%
25	9	1.1%
24	4	0.5%
23	11	1.3%
22	9	1.1%

income
Real number (ℝ)

Distinct	129
Distinct (%)	15.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	46.675294

Minimum	13
Maximum	446
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	6.8 KiB

Quantile statistics

Minimum	13
5-th percentile	17
Q1	24
median	35
Q3	55.75
95-th percentile	115.55
Maximum	446
Range	433
Interquartile range (IQR)	31.75

Descriptive statistics

Standard deviation	38.543054
Coefficient of variation (CV)	0.82576992
Kurtosis	22.485763
Mean	46.675294
Median Absolute Deviation (MAD)	13
Skewness	3.7007613
Sum	39674
Variance	1485.567
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
21	28	3.3%
25	27	3.2%
26	27	3.2%
22	26	3.1%
27	25	2.9%
20	25	2.9%
24	24	2.8%
28	24	2.8%
18	23	2.7%
23	23	2.7%
Other values (119)	598	70.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
13	1	0.1%
14	8	0.9%
15	10	1.2%
16	20	2.4%
17	16	1.9%
18	23	2.7%
19	15	1.8%
20	25	2.9%
21	28	3.3%
22	26	3.1%

Value	Count	Frequency (%)
446	1	0.1%
324	1	0.1%
266	1	0.1%
254	1	0.1%
253	1	0.1%
249	1	0.1%
242	1	0.1%
234	1	0.1%
221	1	0.1%
220	1	0.1%

debtinc
Real number (ℝ)

Distinct	245
Distinct (%)	28.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	10.171647

Minimum	0.1
Maximum	41.3
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	6.8 KiB

Quantile statistics

Minimum	0.1
5-th percentile	1.9
Q1	5.1
median	8.7
Q3	13.8
95-th percentile	23.51
Maximum	41.3
Range	41.2
Interquartile range (IQR)	8.7

Descriptive statistics

Standard deviation	6.7194413
Coefficient of variation (CV)	0.66060504
Kurtosis	1.3876939
Mean	10.171647
Median Absolute Deviation (MAD)	4.2
Skewness	1.1249989
Sum	8645.9
Variance	45.150891
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
5.4	12	1.4%
4.4	10	1.2%
5	10	1.2%
6.7	10	1.2%
4.5	10	1.2%
10.5	9	1.1%
6.4	9	1.1%
3.7	9	1.1%
7.2	9	1.1%
4.1	8	0.9%
Other values (235)	754	88.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.1	1	0.1%
0.4	1	0.1%
0.6	2	0.2%
0.7	1	0.1%
0.8	1	0.1%
0.9	4	0.5%
1	2	0.2%
1.1	4	0.5%
1.2	6	0.7%
1.3	3	0.4%

Value	Count	Frequency (%)
41.3	1	0.1%
36.6	1	0.1%
35.3	1	0.1%
33.4	1	0.1%
33.3	1	0.1%
32.5	2	0.2%
32.4	1	0.1%
32.3	1	0.1%
30.8	1	0.1%
30.7	1	0.1%

creddebt
Real number (ℝ)

Distinct	842
Distinct (%)	99.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.5768047

Minimum	0.011696
Maximum	20.56131
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	6.8 KiB

Quantile statistics

Minimum	0.011696
5-th percentile	0.108927
Q1	0.382176
median	0.8850915
Q3	1.8984405
95-th percentile	5.3486741
Maximum	20.56131
Range	20.549614
Interquartile range (IQR)	1.5162645

Descriptive statistics

Standard deviation	2.12584
Coefficient of variation (CV)	1.3481948
Kurtosis	19.500145
Mean	1.5768047
Median Absolute Deviation (MAD)	0.6067105
Skewness	3.7018998
Sum	1340.284
Variance	4.5191958
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.105	2	0.2%
0.402192	2	0.2%
0.44982	2	0.2%
0.2254	2	0.2%
0.130416	2	0.2%
0.62208	2	0.2%
0.085785	2	0.2%
0.43344	2	0.2%
0.272636	1	0.1%
6.91152	1	0.1%
Other values (832)	832	97.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.011696	1	0.1%
0.014835	1	0.1%
0.02205	1	0.1%
0.024528	1	0.1%
0.024576	1	0.1%
0.025074	1	0.1%
0.029412	1	0.1%
0.029898	1	0.1%
0.030212	1	0.1%
0.030492	1	0.1%

Value	Count	Frequency (%)
20.56131	1	0.1%
16.03147	1	0.1%
15.791776	1	0.1%
15.01668	1	0.1%
14.5962	1	0.1%
14.231448	1	0.1%
13.5525	1	0.1%
11.359392	1	0.1%
10.67934	1	0.1%
9.8766	1	0.1%

othdebt
Real number (ℝ)

Distinct	848
Distinct (%)	99.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.0787894

Minimum	0.045584
Maximum	35.1975
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	6.8 KiB

Quantile statistics

Minimum	0.045584
5-th percentile	0.35989955
Q1	1.045942
median	2.003243
Q3	3.9030008
95-th percentile	9.4811046
Maximum	35.1975
Range	35.151916
Interquartile range (IQR)	2.8570588

Descriptive statistics

Standard deviation	3.3988033
Coefficient of variation (CV)	1.1039415
Kurtosis	16.635286
Mean	3.0787894
Median Absolute Deviation (MAD)	1.132505
Skewness	3.2060225
Sum	2616.971
Variance	11.551864
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
7.8234	2	0.2%
3.166086	2	0.2%
5.008608	1	0.1%
1.755775	1	0.1%
0.775372	1	0.1%
0.682176	1	0.1%
3.9468	1	0.1%
0.364364	1	0.1%
4.51248	1	0.1%
4.799355	1	0.1%
Other values (838)	838	98.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.045584	1	0.1%
0.05295	1	0.1%
0.089488	1	0.1%
0.100926	1	0.1%
0.10752	1	0.1%
0.129582	1	0.1%
0.15012	1	0.1%
0.1563	1	0.1%
0.160983	1	0.1%
0.163863	1	0.1%

Value	Count	Frequency (%)
35.1975	1	0.1%
27.0336	1	0.1%
23.104224	1	0.1%
20.615868	1	0.1%
18.26913	1	0.1%
18.257382	1	0.1%
17.79899	1	0.1%
17.2038	1	0.1%
17.184552	1	0.1%
16.668126	1	0.1%

default
Categorical

Distinct	2
Distinct (%)	0.3%
Missing	150
Missing (%)	17.6%
Memory size	6.8 KiB

0.0	517
1.0	183

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	2100
Distinct characters	3
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1.0
2nd row	0.0
3rd row	0.0
4th row	0.0
5th row	1.0

Common Values

Value	Count	Frequency (%)
0.0	517	60.8%
1.0	183	21.5%
(Missing)	150	17.6%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0.0	517	73.9%
1.0	183	26.1%

Most occurring characters

Value	Count	Frequency (%)
0	1217	58.0%
.	700	33.3%
1	183	8.7%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	1400	66.7%
Other Punctuation	700	33.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	1217	86.9%
1	183	13.1%

Other Punctuation

Value	Count	Frequency (%)
.	700	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	2100	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	1217	58.0%
.	700	33.3%
1	183	8.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2100	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	1217	58.0%
.	700	33.3%
1	183	8.7%

Auto

Heatmap
Table

	age	employ	address	income	debtinc	creddebt	othdebt	ed	default
age	1.000	0.547	0.561	0.574	-0.001	0.295	0.334	0.029	0.179
employ	0.547	1.000	0.325	0.707	-0.070	0.318	0.354	0.054	0.310
address	0.561	0.325	1.000	0.345	-0.014	0.206	0.191	0.069	0.200
income	0.574	0.707	0.345	1.000	-0.021	0.503	0.557	0.176	0.111
debtinc	-0.001	-0.070	-0.014	-0.021	1.000	0.615	0.713	0.000	0.404
creddebt	0.295	0.318	0.206	0.503	0.615	1.000	0.613	0.061	0.213
othdebt	0.334	0.354	0.191	0.557	0.713	0.613	1.000	0.086	0.114
ed	0.029	0.054	0.069	0.176	0.000	0.061	0.086	1.000	0.103
default	0.179	0.310	0.200	0.111	0.404	0.213	0.114	0.103	1.000

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	age	ed	employ	address	income	debtinc	creddebt	othdebt	default
0	41	3	17	12	176	9.3	11.359392	5.008608	1.0
1	27	1	10	6	31	17.3	1.362202	4.000798	0.0
2	40	1	15	14	55	5.5	0.856075	2.168925	0.0
3	41	1	15	14	120	2.9	2.658720	0.821280	0.0
4	24	2	2	0	28	17.3	1.787436	3.056564	1.0
5	41	2	5	5	25	10.2	0.392700	2.157300	0.0
6	39	1	20	9	67	30.6	3.833874	16.668126	0.0
7	43	1	12	11	38	3.6	0.128592	1.239408	0.0
8	24	1	3	4	19	24.4	1.358348	3.277652	1.0
9	36	1	0	13	25	19.7	2.777700	2.147300	0.0

	age	ed	employ	address	income	debtinc	creddebt	othdebt	default
840	35	2	11	1	62	32.4	9.702504	10.385496	NaN
841	35	4	10	12	45	8.5	1.040400	2.784600	NaN
842	51	4	15	30	26	13.6	2.011984	1.524016	NaN
843	36	1	5	2	27	7.0	0.723870	1.166130	NaN
844	23	1	3	4	13	3.1	0.045539	0.357461	NaN
845	34	1	12	15	32	2.7	0.239328	0.624672	NaN
846	32	2	12	11	116	5.7	4.026708	2.585292	NaN
847	48	1	13	11	38	10.8	0.722304	3.381696	NaN
848	35	2	1	11	24	7.8	0.417456	1.454544	NaN
849	37	1	20	13	41	12.9	0.899130	4.389870	NaN

Overview

Variables

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Other Punctuation

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Interactions

Correlations

Missing values

Sample